Returns the column value in the current row of a recordset.
Syntax
GetRowValue(Recordset, "ColumnName")
Arguments
Argument | Description |
---|---|
Recordset | Recordset object that contains the row to retrieve the value from. Must be opened with OpenRecordset or OpenRecordsetQuery. |
ColumnName | Column name to retrieve the value from. |
Return value
Value | Description |
---|---|
Value | Value from the cell in the column. |
Example
bugs = OpenRecordset("WysiCorp Bugs")
NextRow(bugs)
If Not RecordsetEOF(bugs) Then
firstName = GetRowValue(bugs, "first name")
Window("Feedback").Editbox("editboxFirst").SetText(firstName)
Window("Browser").Close()
Else
Fail("Error: second record does not exist")
End If